﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.Project
{
    public partial class ProjectInfo
    {
        public const string INSERT_SQL = "insert into [Project] ( ID, Name, TypeCode, Budget, CreatorID, CreatorName, PMID, PMName, InnerMembers, OuterMembers, StartTime, EndTime, Importance, Status, Remark, Orders) values ( @ID, @Name, @TypeCode, @Budget, @CreatorID, @CreatorName, @PMID, @PMName, @InnerMembers, @OuterMembers, @StartTime, @EndTime, @Importance, @Status, @Remark, @Orders)";
        public const string UPDATE_SQL = "update [Project] set  ID = @ID, Name = @Name, TypeCode = @TypeCode, Budget = @Budget, CreatorID = @CreatorID, CreatorName = @CreatorName, PMID = @PMID, PMName = @PMName, InnerMembers = @InnerMembers, OuterMembers = @OuterMembers, StartTime = @StartTime, EndTime = @EndTime, Importance = @Importance, Status = @Status, Remark = @Remark, Orders = @Orders where ID = @ID";
        public ProjectInfo() { }
        public int ID
        {
            get;
            set;
        }
        public string Name
        {
            get;
            set;
        }
        public int TypeCode
        {
            get;
            set;
        }
        public decimal Budget
        {
            get;
            set;
        }
        public int CreatorID
        {
            get;
            set;
        }
        public string CreatorName
        {
            get;
            set;
        }
        public int PMID
        {
            get;
            set;
        }
        public string PMName
        {
            get;
            set;
        }
        public string InnerMembers
        {
            get;
            set;
        }
        public string InnerMemberIDs
        {
            get;
            set;
        }
        public string OuterMembers
        {
            get;
            set;
        }
        public DateTime StartTime
        {
            get;
            set;
        }
        public DateTime EndTime
        {
            get;
            set;
        }
        public int Importance
        {
            get;
            set;
        }
        public int Status
        {
            get;
            set;
        }
        public string Remark
        {
            get;
            set;
        }
        public int Orders
        {
            get;
            set;
        }
    }

}
